<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Ad_ExportToXls.aspx.cs" Inherits="Admin_reports_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Export To Excel</title>
</head>
<body>
    <form id="frmExport" runat="server">
    <div>
        
<asp:GridView id="ProfileGrid" width="700px" Runat="Server"
  AutoGenerateColumns="False"
  ShowFooter="False"
  Caption="<b>Number of Doctors that have accessed their profile </b>"
 
>
<EmptyDataRowStyle width="700px"  
          forecolor="Red"/>
                    
        <EmptyDataTemplate>
                
                        
            No Data Found.  
                
        </emptydatatemplate> 
                

  <Columns>
    
  <asp:BoundField
    DataField="UPin"
    HeaderText="ID"
    FooterStyle-BorderWidth="0"/>
  
  <asp:BoundField
    DataField="Title"
    HeaderText="Title"
    FooterStyle-BorderWidth="0"/>
  
  <asp:BoundField
    DataField="FName"
    HeaderText="First Name"
    FooterStyle-BorderWidth="0"/>
    
    <asp:BoundField
    DataField="MName"
    HeaderText="Middle Name"
    FooterStyle-BorderWidth="0"/>



  <asp:BoundField
    DataField="LName"
    HeaderText="Last Name"
    FooterStyle-BorderWidth="0"/>
    
     <asp:BoundField
    DataField="Email"
    HeaderText="Email"
    FooterStyle-BorderWidth="0"/> 
    
     <asp:BoundField
    DataField="Password"
    HeaderText="Password"
    FooterStyle-BorderWidth="0"/>
    
     <asp:BoundField
    DataField="Phone"
    HeaderText="Phone"
    FooterStyle-BorderWidth="0"/>


     <asp:BoundField
    DataField="Fax"
    HeaderText="Fax"
    FooterStyle-BorderWidth="0"/>
    
       

     <asp:BoundField
    DataField="Address1"
    HeaderText="Address1"
    FooterStyle-BorderWidth="0"/>
    
    
     <asp:BoundField
    DataField="Address2"
    HeaderText="Address2"
    FooterStyle-BorderWidth="0"/>
    
    
     <asp:BoundField
    DataField="City"
    HeaderText="City"
    FooterStyle-BorderWidth="0"/>
  
     <asp:BoundField
    DataField="CountryID"
    HeaderText="CountryID"
    FooterStyle-BorderWidth="0"/>
    <asp:BoundField
    DataField="Languages"
    HeaderText="Languages"
    FooterStyle-BorderWidth="0"/>
   
    <asp:BoundField
    DataField="county"
    HeaderText="county"
    FooterStyle-BorderWidth="0"/>
    <asp:BoundField
    DataField="Cmsa"
    HeaderText="Cmsa"
    FooterStyle-BorderWidth="0"/>
    <asp:BoundField
    DataField="Msa"
    HeaderText="Msa"
    FooterStyle-BorderWidth="0"/>
    <asp:BoundField
    DataField="ZipCode"
    HeaderText="ZipCode"
    FooterStyle-BorderWidth="0"/>
    
    <asp:BoundField
    DataField="Gender"
    HeaderText="Gender"
    FooterStyle-BorderWidth="0"/>
    
    <asp:BoundField
    DataField="Speciality"
    HeaderText="Speciality"
    FooterStyle-BorderWidth="0"/>
    
    <asp:BoundField
    DataField="Primary Speciality"
    HeaderText="Primary Speciality"
    FooterStyle-BorderWidth="0"/>
    
    <asp:BoundField
    DataField="Secondary Speciality"
    HeaderText="Secondary Speciality"
    FooterStyle-BorderWidth="0"/>
    

   <asp:BoundField
    DataField="Major Activity"
    HeaderText="Major Activity"
    FooterStyle-BorderWidth="0"/>

    <asp:BoundField
    DataField="GraduationYear"
    HeaderText="GraduationYear"
    FooterStyle-BorderWidth="0"/>
    <asp:BoundField
    DataField="Hospital"
    HeaderText="Hospital"
    FooterStyle-BorderWidth="0"/>
    
   <asp:BoundField
    DataField="Insurance Company"
    HeaderText="Insurance Company"
    FooterStyle-BorderWidth="0"/>
    
    <asp:BoundField
    DataField="ResidencyTraining"
    HeaderText="ResidencyTraining"
    FooterStyle-BorderWidth="0"/>
    <asp:BoundField
    DataField="GroupPractice"
    HeaderText="GroupPractice"
    FooterStyle-BorderWidth="0"/>
    
<asp:BoundField
    DataField="AdvancedTraining"
    HeaderText="AdvancedTraining"
    FooterStyle-BorderWidth="0"/>
    <asp:BoundField
    DataField="Awards"
    HeaderText="Awards"
    FooterStyle-BorderWidth="0"/>
    <asp:BoundField
    DataField="Fellowship"
    HeaderText="Fellowship"
    FooterStyle-BorderWidth="0"/>
    <asp:BoundField
    DataField="RegDate"
    HeaderText="RegDate(mm/dd/yyyy)"
    dataformatstring="{0:MM/dd/yyyy}" 
    HtmlEncode="false"
    FooterStyle-BorderWidth="0"/>
    <asp:BoundField
    DataField="AccessProfileDate"
    HeaderText="AccessProfileDate(mm/dd/yyyy)"
    dataformatstring="{0:MM/dd/yyyy}" 
    HtmlEncode="false"
    FooterStyle-BorderWidth="0"/>
  </Columns>

</asp:GridView>


<asp:GridView id="UserGrid"  Runat="Server"
  AutoGenerateColumns="False"
  ShowFooter="False"
  Width="700px"
  Caption="<b>Number of New Users </b>"
 
>
<emptydatarowstyle backcolor="LightBlue" Width="700px"
          forecolor="Red"/>
                    
        <emptydatatemplate>
                
                        
            No Data Found.  
                
        </emptydatatemplate> 
                
  <Columns>
    
  <asp:BoundField
    DataField="First Name"
    HeaderText="First Name"
    FooterStyle-BorderWidth="0"/>
  
  <asp:BoundField
    DataField="Middle Name"
    HeaderText="Middle Name"
    FooterStyle-BorderWidth="0"/>
  
  <asp:BoundField
    DataField="BirthYear"
    HeaderText="BirthYear"
    FooterStyle-BorderWidth="0"/>
    
    <asp:BoundField
    DataField="Email"
    HeaderText="Email"
    FooterStyle-BorderWidth="0"/>



  <asp:BoundField
    DataField="Password"
    HeaderText="Password"
    FooterStyle-BorderWidth="0"/>
    
    
    
     <asp:BoundField
    DataField="Gender"
    HeaderText="Gender"
    FooterStyle-BorderWidth="0"/> 
    
     <asp:BoundField
    DataField="Address1"
    HeaderText="Address1"
    FooterStyle-BorderWidth="0"/>
    
     <asp:BoundField
    DataField="Address2"
    HeaderText="Address2"
    FooterStyle-BorderWidth="0"/>


     <asp:BoundField
    DataField="City"
    HeaderText="City"
    FooterStyle-BorderWidth="0"/>
    
       

     <asp:BoundField
    DataField="ZipCode"
    HeaderText="ZipCode"
    FooterStyle-BorderWidth="0"/>
    
    
     <asp:BoundField
    DataField="HealthC Plan"
    HeaderText="HealthC Plan"
    FooterStyle-BorderWidth="0"/>
    
    
     <asp:BoundField
    DataField="Security Question"
    HeaderText="Security Question"
    FooterStyle-BorderWidth="0"/>
  
     <asp:BoundField
    DataField="Security Answer"
    HeaderText="Security Answer"
    FooterStyle-BorderWidth="0"/>
    <asp:BoundField
    DataField="NickName"
    HeaderText="NickName"
    FooterStyle-BorderWidth="0"/>
   
    <asp:BoundField
    DataField="Freeoffer"
    HeaderText="Freeoffer"
    FooterStyle-BorderWidth="0"/>
    
    
    <asp:BoundField
    DataField="Countryid"
    HeaderText="Country"
    FooterStyle-BorderWidth="0"/>
    <asp:BoundField
    DataField="RegDate"
    HeaderText="RegDate(mm/dd/yyyy)"
    dataformatstring="{0:MM/dd/yyyy}" 
    HtmlEncode="false"
    FooterStyle-BorderWidth="0"/>
    
  </Columns>

</asp:GridView>

    </div>
    </form>
   
    

</body>
</html>
